create table t_page(
id number(10) primary key,
name varchar2(50)
);
create sequence seq_page;
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');
insert into t_page(id,name)values(seq_page.nextval,'张三');


SELECT * FROM  
(  
SELECT A.*, ROWNUM RN  
FROM (SELECT * FROM t_page) A  
WHERE ROWNUM <= 5
)  
WHERE RN > 0;


SELECT * FROM  
(  
SELECT A.*, ROWNUM RN  
FROM (SELECT * FROM t_page) A  
WHERE ROWNUM <= 10
)  
WHERE RN > 5;

SELECT * FROM  
(  
SELECT A.*, ROWNUM RN  
FROM (SELECT * FROM t_page) A  
WHERE ROWNUM <= 15
)  
WHERE RN > 10;